﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Globalization;
using System.Linq;
using FarPoint.Win.Spread;
using FarPoint.Win.Spread.CellType;
using FarPoint.Win;
using Spread.Common.DataStore.DataSourceEntities;
using Spread.Common.DataStore;
using Spread.Common.DataStore.Models;

namespace GrapeCity.FinancialKPI
{
    public partial class FinancialKPIControl : Spread.Common.Features.Sample.BaseSampleControl
    {
        #region Private variables
        private static bool _isSheetReset;
        private DateTimeFormatInfo _dateFormatInfo;
        private DateTime _date;

        private FinancialKPIDataSource _dataSource;
        private FinancialKPIList _kpiList;
        private List<FinancialTargetMaster> _targetMasterList;
        private FinancialTargetMaster _currentMonthTargetMaster;
        private FinancialTargetMaster _previousMonthTargetMaster;

        private NumberCellType _numCell;
        private CurrencyCellType _currencyCell;
        private PercentCellType _percentCell;
        private MaskCellType _maskDaysCell;
        private MaskCellType _maskActivityRatioCell;
        private MaskCellType _maskRatioCell;
        private ComboBoxCellType _comboCellMonth;

        private Color _greenColor;

        private string _tickSymbol;
        private string _crossSymbol;
        private string _upSymbol;
        private string _downSymbol;
        private string _noChangeSymbol;
        #endregion

        #region ctor
        public FinancialKPIControl()
        {
            InitializeComponent();

            _tickSymbol = "✓";
            _crossSymbol = "✕";
            _upSymbol = "▲";
            _downSymbol = "▼";
            _noChangeSymbol = "▬";

            _greenColor = Color.FromArgb(0, 176, 80);

            _numCell = new NumberCellType
            {
                DecimalPlaces = 0
            };

            _currencyCell = new CurrencyCellType
            {
                CurrencySymbol = "$",
                DecimalPlaces = 0,
                ShowSeparator = true,
                FocusPosition = EditorFocusCursorPosition.End
            };

            _percentCell = new PercentCellType
            {
                DecimalPlaces = 2,
                PercentSign = "%",
                FocusPosition = EditorFocusCursorPosition.End
            };

            _maskDaysCell = new MaskCellType
            {
                NullDisplay = string.Empty,
                MaskChar = ' ',
                Mask = "XXX days"
            };

            _maskActivityRatioCell = new MaskCellType
            {
                NullDisplay = string.Empty,
                MaskChar = ' ',
                Mask = "XXXX times"
            };

            _maskRatioCell = new MaskCellType
            {
                NullDisplay = string.Empty,
                MaskChar = ' ',
                Mask = @"XXXX:\1"
            };

            _dateFormatInfo = new CultureInfo("en-US").DateTimeFormat;
            _dataSource = new DataService().FinancialKPIDataSource;
            _kpiList = _dataSource.GetAllKPIs();
            _targetMasterList = _dataSource.GetAllTargets();

            Load += FinancialKPIControl_Load;
        }
        #endregion

        #region Event handlers
        private void FinancialKPIControl_Load(object sender, EventArgs e)
        {
            // Load sheet from template
            fpSpread.ActiveSheet.OpenExcel(@"Template\Financial KPIs.xlsx", 0);
            fpSpread.Sheets.Add(new SheetView("Workspace"));

            fpSpread.SuspendLayout();
            SetSheetProperties(fpSpread.Sheets[0]);
            AddComboSelector(fpSpread.Sheets[0]);
            LoadData(fpSpread.Sheets[0]);

            SetSecondarySheetProperties(fpSpread.Sheets["Workspace"]);

            fpSpread.ResumeLayout(true);
        }

        // Event handler to update data when ComboBox selection is changed
        private void ComboCell_EditingStopped(object sender, EventArgs e)
        {
            fpSpread.SuspendLayout();
            LoadData(fpSpread.Sheets[0]);
            fpSpread.ResumeLayout(true);
        }
        #endregion

        #region Private methods
        // Set sheet properties for Main sheet
        private void SetSheetProperties(SheetView sheet)
        {
            sheet.FpSpread.Font = new Font("Helvetica Neue", 10, FontStyle.Regular);

            sheet.RowCount = 26;
            sheet.ColumnCount = 9;
            sheet.FpSpread.TabStripPolicy = TabStripPolicy.Always;
            sheet.FpSpread.TabStripInsertTab = false;
            sheet.FpSpread.ButtonDrawMode = ButtonDrawModes.Always;
            sheet.RowHeader.Visible = false;
            sheet.ColumnHeader.Visible = false;

            sheet.Columns[3].Visible = false;

            sheet.Columns[2].Width = 450;
            sheet.Columns[4, 5].Width = 180;
            sheet.Columns[6, 7].Width = 40;
            sheet.Columns[8].Width = 180;

            // Set KPI Names
            int row = 6;
            foreach (var item in _kpiList.Items)
            {
                // Check if row in KPI group header
                if (sheet.Cells[row, 1].Text.Length == 1)
                {
                    ++row;
                }
                sheet.Cells[row++, 1].Text = item.Value.Name;
            }

            // BackColor for header
            sheet.Cells[1, 0, 2, sheet.ColumnCount - 1].BackColor = Color.FromArgb(232, 217, 174);

            sheet.Cells[2, 4].Tag = "DataErrorCell";
            sheet.Cells[2, 4].Font = new Font("Segoe UI", 12, FontStyle.Regular);
            sheet.Cells[2, 4].HorizontalAlignment = CellHorizontalAlignment.Center;
            sheet.Cells[2, 4].VerticalAlignment = CellVerticalAlignment.Center;

            sheet.Cells[6, 3, sheet.RowCount - 1, sheet.ColumnCount - 1].ResetCellType();

            SetActualAndTargetCellTypes(sheet, 6, 4);
            SetTrendCellTypes(sheet, 6, 8);

            sheet.Protect = true;
            sheet.Cells[4, 4, sheet.RowCount - 1, sheet.ColumnCount - 1].Locked = true;

            SetupFormulas();
            SetupConditionalFormatting(sheet);
        }

        private void SetupFormulas()
        {
            SheetView mainSheet = fpSpread.Sheets[0];
            
            for (int row = 5; row < mainSheet.RowCount; ++row)
            {
                string kpi = mainSheet.Cells[row, 1].Text;
                if (_kpiList.Items.Values.Any(value => value.Name == kpi))
                {
                    var itemPair = _kpiList.Items.Where(item => item.Value.Name == kpi).First();
                    mainSheet.Cells[row, 4].Formula = $"Workspace!$C${itemPair.Key + 2}";
                    mainSheet.Cells[row, 5].Formula = $"Workspace!$D${itemPair.Key + 2}";

                    if (itemPair.Value.Type == KPIType.Liability)
                        mainSheet.Cells[row, 6].Formula = $"IF(Sheet1!$E${row} <= Sheet1!$F${row}, \"{_tickSymbol}\", \"{_crossSymbol}\")";
                    else
                        mainSheet.Cells[row, 6].Formula = $"IF(Sheet1!$E${row} >= Sheet1!$F${row}, \"{_tickSymbol}\", \"{_crossSymbol}\")";

                    string trendFormula = $"(Workspace!$C${itemPair.Key + 2} - Workspace!$H${itemPair.Key + 2})";
                    if (itemPair.Value.Name.Contains("Revenue"))
                        trendFormula += $" / Workspace!$H${itemPair.Key + 2}";
                    mainSheet.Cells[row, 8].Formula = trendFormula;
                }
            }
        }

        private void SetupConditionalFormatting(SheetView sheet)
        {
            UnaryComparisonConditionalFormattingRule rule1 = new UnaryComparisonConditionalFormattingRule(UnaryComparisonOperator.EqualTo,
                _tickSymbol, false);
            rule1.ForeColor = Color.Green;
            UnaryComparisonConditionalFormattingRule rule2 = new UnaryComparisonConditionalFormattingRule(UnaryComparisonOperator.EqualTo,
                _crossSymbol, false);
            rule2.ForeColor = Color.Red;
            sheet.SetConditionalFormatting(5, 6, sheet.RowCount - 4, 1, false, rule1, rule2);
        }

        // Set celltypes for Actual and Target columns
        private void SetActualAndTargetCellTypes(SheetView sheet, int row, int col)
        {
            sheet.Cells[row, col, row, col + 1].CellType = _currencyCell;
            sheet.Cells[row + 1, col, row + 3, col + 1].CellType = _percentCell;
            sheet.Cells[row + 5, col, row + 5, col + 1].CellType = _maskActivityRatioCell;
            sheet.Cells[row + 6, col, row + 7, col + 1].CellType = _maskDaysCell;
            sheet.Cells[row + 9, col, row + 10, col + 1].CellType = _percentCell;
            sheet.Cells[row + 12, col, row + 13, col + 1].CellType = _maskRatioCell;
            sheet.Cells[row + 15, col, row + 19, col + 1].CellType = _percentCell;
        }

        // Set celltypes for Trend column
        private void SetTrendCellTypes(SheetView sheet, int row, int col)
        {
            sheet.Cells[row, col, row + 3, col].CellType = _percentCell;
            sheet.Cells[row + 5, col].CellType = _maskActivityRatioCell;
            sheet.Cells[row + 6, col, row + 7, col].CellType = _maskDaysCell;
            sheet.Cells[row + 9, col, row + 10, col].CellType = _percentCell;
            sheet.Cells[row + 12, col, row + 13, col].CellType = _maskRatioCell;
            sheet.Cells[row + 15, col, row + 19, col].CellType = _percentCell;
        }

        // Set properties for Secondary sheet
        private void SetSecondarySheetProperties(SheetView sheet)
        {
            sheet.ColumnCount = 9;
            sheet.RowCount = _kpiList.Items.Count + 2;

            sheet.Columns[0, sheet.ColumnCount - 1].VerticalAlignment = CellVerticalAlignment.Center;
            sheet.Columns[0, sheet.ColumnCount - 1].HorizontalAlignment = CellHorizontalAlignment.Center;

            sheet.Rows[0].Height = 40;
            sheet.Rows[0].Font = new Font("Segoe UI", 14, FontStyle.Bold);
            sheet.Rows[0].VerticalAlignment = CellVerticalAlignment.Center;
            sheet.Rows[0].HorizontalAlignment = CellHorizontalAlignment.Left;
            sheet.AddSpanCell(0, 0, 1, 4);
            sheet.AddSpanCell(0, 5, 1, 4);

            sheet.Columns[0].Width = 80;
            sheet.Columns[1].Width = 240;
            sheet.Columns[2, 3].Width = 120;
            sheet.Columns[4, 5].Width = 80;
            sheet.Columns[6].Width = 240;
            sheet.Columns[7, 8].Width = 120;

            sheet.Columns[1].HorizontalAlignment = CellHorizontalAlignment.Left;
            sheet.Columns[6].HorizontalAlignment = CellHorizontalAlignment.Left;

            sheet.Rows[1, sheet.RowCount - 1].Height = 25;

            sheet.AlternatingRows.Count = 2;
            sheet.AlternatingRows[0].BackColor = Color.FromArgb(246, 246, 246);
            sheet.AlternatingRows[1].BackColor = Color.FromArgb(218, 218, 218);

            // Back Color and Border for column separating Current and Previous Month data tables
            sheet.Columns[4].BackColor = Color.FromKnownColor(KnownColor.Window);
            sheet.Cells[0, 4, sheet.RowCount - 1, 4].Border = new LineBorder(Color.FromKnownColor(KnownColor.Window),
                1, false, true, false, true);

            // Lock whole sheet, then unlock cells containing data values
            sheet.Cells[0, 0, sheet.RowCount - 1, sheet.ColumnCount - 1].Locked = true;
            sheet.Cells[2, 2, sheet.RowCount - 1, 3].Locked = false;
            sheet.Cells[2, 7, sheet.RowCount - 1, 8].Locked = false;

            SetSecondarySheetCellTypes(sheet, 2, 2);
            SetSecondarySheetCellTypes(sheet, 2, 7);

            LoadMonthlyData(sheet, 0, 0);
        }

        // Set celltypes for Secondary sheet
        private void SetSecondarySheetCellTypes(SheetView sheet, int row, int col)
        {
            sheet.Cells[row, col, row, col + 1].CellType = _currencyCell;
            sheet.Cells[row + 1, col, row + 3, col + 1].CellType = _percentCell;
            sheet.Cells[row + 4, col, row + 4, col + 1].CellType = _maskActivityRatioCell;
            sheet.Cells[row + 5, col, row + 6, col + 1].CellType = _maskDaysCell;
            sheet.Cells[row + 7, col, row + 8, col + 1].CellType = _percentCell;
            sheet.Cells[row + 9, col, row + 10, col + 1].CellType = _maskRatioCell;
            sheet.Cells[row + 11, col, row + 14, col + 1].CellType = _percentCell;
        }

        // Add Month & Year ComboBox
        private void AddComboSelector(SheetView sheet)
        {
            sheet.Cells[1, 4, 1, 8].Font = new Font(sheet.FpSpread.Font.SystemFontName, 12, FontStyle.Bold);
            sheet.Cells[1, 4, 1, 8].VerticalAlignment = CellVerticalAlignment.Center;

            _comboCellMonth = new ComboBoxCellType
            {
                DropDownOptions = FarPoint.Win.DropDownOptions.ButtonAndText,
                Editable = false,
                Items = _dateFormatInfo.MonthNames,
                ListWidth = 110,
                StopEditingAfterDropDownItemSelected = true
            };
            _comboCellMonth.EditingStopped += ComboCell_EditingStopped;

            ComboBoxCellType comboCellYear = new ComboBoxCellType
            {
                DropDownOptions = FarPoint.Win.DropDownOptions.ButtonAndText,
                Editable = false,
                Items = new string[] { (DateTime.Now.Year - 2).ToString(), (DateTime.Now.Year - 1).ToString(),
                    DateTime.Now.Year.ToString() },
                StopEditingAfterDropDownItemSelected = true
            };
            comboCellYear.EditingStopped += ComboCell_EditingStopped;

            sheet.Cells[1, 4].Text = "Month";
            sheet.Cells[1, 4].HorizontalAlignment = CellHorizontalAlignment.Right;

            sheet.Cells[1, 5].HorizontalAlignment = CellHorizontalAlignment.Center;
            sheet.Cells[1, 5].CellType = _comboCellMonth;
            sheet.Cells[1, 5].Value = DateTime.Now.ToString("MMMM");
            sheet.Cells[1, 5].Locked = false;
            sheet.Cells[1, 5].Tag = "MonthCell";

            sheet.AddSpanCell(1, 6, 1, 2);
            sheet.Cells[1, 6].Text = "Year";
            sheet.Cells[1, 6].HorizontalAlignment = CellHorizontalAlignment.Right;

            sheet.Cells[1, 8].HorizontalAlignment = CellHorizontalAlignment.Center;
            sheet.Cells[1, 8].CellType = comboCellYear;
            sheet.Cells[1, 8].Value = DateTime.Now.ToString("yyyy");
            sheet.Cells[1, 8].Locked = false;
            sheet.Cells[1, 8].Tag = "YearCell";

            sheet.AddSpanCell(2, 4, 1, 5);
            sheet.Cells[2, 4].Font = new Font("Segoe UI", 11, FontStyle.Bold);
            sheet.Cells[2, 4].HorizontalAlignment = CellHorizontalAlignment.Center;
        }

        // Load Current and Previous Month data in Secondary sheet
        private void LoadMonthlyData(SheetView sheet, int row, int col)
        {
            if (_currentMonthTargetMaster == null)
                ClearData(sheet, row, col, sheet.RowCount - 1, col + 4);
            else
                LoadMonthlyData(sheet, row, col, _currentMonthTargetMaster);

            if (_previousMonthTargetMaster == null)
                ClearData(sheet, row, col + 5, sheet.RowCount - 1, sheet.ColumnCount - 1);
            else
                LoadMonthlyData(sheet, row, col + 5, _previousMonthTargetMaster);
        }

        // Load given data from TargetMaster in Secondary sheet
        private void LoadMonthlyData(SheetView sheet, int row, int col, FinancialTargetMaster targetMaster)
        {
            DateTime date = new DateTime(targetMaster.Year, targetMaster.Month, 1);
            sheet.Cells[row, col].BackColor = Color.FromArgb(232, 217, 174);
            sheet.Cells[row, col].Value = $"KPI data for {date.ToString("MMM, yyyy")}";
            ++row;

            sheet.Cells[row, col, row, col + 3].BackColor = Color.DarkGray;
            sheet.Cells[row, col, row, col + 3].ForeColor = Color.WhiteSmoke;
            sheet.Cells[row, col].Value = "KPI ID";
            sheet.Cells[row, col + 1].Value = "KPI Name";
            sheet.Columns[col + 1].HorizontalAlignment = CellHorizontalAlignment.Center;
            sheet.Cells[row, col + 2].Value = "Actual";
            sheet.Cells[row, col + 3].Value = "Target";

            for (int i = 1; i <= _kpiList.Items.Count; ++i)
            {
                sheet.Cells[row + i, col].Value = i;
                sheet.Cells[row + i, col + 1].Value = _kpiList.Items[i].Name;
                sheet.Cells[row + i, col + 2].Value = Math.Round((decimal)targetMaster.KPITargets[i - 1].Actual, 4);
                sheet.Cells[row + i, col + 3].Value = Math.Round((decimal)targetMaster.KPITargets[i - 1].Target, 4);
            }
        }

        // Load data in Secondary sheet using selected Month & Year in ComboBox
        private void LoadSelectedMonthData()
        {
            int year = int.Parse(fpSpread.Sheets[0].Cells["YearCell"].Value.ToString());
            _comboCellMonth.Items = _dateFormatInfo.MonthNames.Take((year == DateTime.Now.Year) ? DateTime.Now.Month : 12).ToArray();
            if (fpSpread.Sheets[0].Cells["MonthCell"].Text == string.Empty)
                fpSpread.Sheets[0].Cells["MonthCell"].Value = _comboCellMonth.Items.Last();

            int month = _dateFormatInfo.MonthNames.ToList().IndexOf(fpSpread.Sheets[0].Cells["MonthCell"].Value.
                ToString()) + 1;
            _date = new DateTime(year, month, 1);
            DateTime prevMonthDate = _date.AddMonths(-1);

            fpSpread.Sheets[0].Cells[5, 4].Value = _date.ToString("MMM yyyy");
            fpSpread.Sheets[0].Cells[5, 7].Value = $"vs {_date.AddMonths(-1).ToString("MMM yyyy")}";

            _currentMonthTargetMaster = _targetMasterList.Where(t => t.Month == _date.Month && t.Year == _date.Year).FirstOrDefault();
            _previousMonthTargetMaster = _targetMasterList.Where(t => t.Month == prevMonthDate.Month &&
                t.Year == prevMonthDate.Year).FirstOrDefault();

            LoadMonthlyData(fpSpread.Sheets["Workspace"], 0, 0);
        }

        // Load data and update Trend metric if relative Trend value is not available
        private void LoadData(SheetView sheet)
        {
            LoadSelectedMonthData();

            if (_currentMonthTargetMaster == null)
            {
                sheet.ClearRange(5, 4, sheet.RowCount - 1, sheet.ColumnCount - 1, true);
                sheet.Cells["DataErrorCell"].Value = $"No data available for {_date.ToString("MMM yyyy")}";
                _isSheetReset = true;
                return;
            }
            sheet.Cells["DataErrorCell"].ResetValue();

            if (_isSheetReset)
            {
                SetupFormulas();
                _isSheetReset = false;
            }

            // Use Target value as relative value if Previous Month data is not available
            if (_previousMonthTargetMaster != null)
            {
                FillTrendColumn(sheet, 6, 8, 2, 7);
                sheet.Cells[5, 7].Value = $"vs {_date.AddMonths(-1).ToString("MMM yyyy")}";
            }
            else
            {
                FillTrendColumn(sheet, 6, 8, 2, 3);
                sheet.Cells[5, 7].Value = $"vs Target";
            }
        }

        // Set trend symbol for Trend column
        private void FillTrendColumn(SheetView sheet, int row, int col, int srcCol1, int srcCol2)
        {
            fpSpread.ResumeLayout(true);
            while (row < sheet.RowCount)
            {
                string kpi = sheet.Cells[row, 1].Text;
                if (_kpiList.Items.Values.Any(value => value.Name == kpi))
                {
                    double value = Convert.ToDouble(sheet.Cells[row, col].Value);

                    // Assign _upSymbol to favorable Trend value
                    KPIType kpiType = _kpiList.Items.Where(item => item.Value.Name ==
                        sheet.Cells[row, col - 7].Text).First().Value.Type;

                    if (kpiType == KPIType.Liability)
                        SetCellSymbol(sheet, row, col - 1, (value >= 0) ? (value > 0 ? _upSymbol :
                            _noChangeSymbol) : _downSymbol, true);
                    else
                        SetCellSymbol(sheet, row, col - 1, (value >= 0) ? (value > 0 ? _upSymbol :
                            _noChangeSymbol) : _downSymbol);
                }
                ++row;
            }
        }

        // Set ForeColor and Value in a cell
        private void SetCellSymbol(SheetView sheet, int row, int col, string symbol, bool swapColors = false)
        {
            if (symbol == _upSymbol)
            {
                sheet.Cells[row, col].ForeColor = (swapColors) ? Color.Red : _greenColor;
            }
            else if (symbol == _downSymbol)
            {
                sheet.Cells[row, col].ForeColor = (swapColors) ? _greenColor : Color.Red;
            }
            else
            {
                sheet.Cells[row, col].ForeColor = Color.DarkOrange;
            }
            sheet.Cells[row, col].Value = symbol;
        }

        // Clear previous data
        private void ClearData(SheetView sheet, int startRow, int startCol, int endRow, int endCol)
        {
            sheet.Cells[startRow, startCol, endRow, endCol].ResetValue();
            sheet.Cells[startRow, startCol].ResetBackColor();
            sheet.Cells[startRow + 1, startCol, startRow + 1, startCol + 3].ResetBackColor();
        }
        #endregion
    }
}


//
//FinancialKPIControl.Designer.cs
//


namespace GrapeCity.FinancialKPI
{
    partial class FinancialKPIControl
    {
        /// <summary> 
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary> 
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Component Designer generated code

        /// <summary> 
        /// Required method for Designer support - do not modify 
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.fpSpread = new FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None);
            this.fpSpread_Sheet1 = new FarPoint.Win.Spread.SheetView();
            this.pnlMain.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread_Sheet1)).BeginInit();
            this.SuspendLayout();
            // 
            // pnlMain
            // 
            this.pnlMain.Controls.Add(this.fpSpread);
            // 
            // fpSpread
            // 
            this.fpSpread.AccessibleDescription = "";
            this.fpSpread.Dock = System.Windows.Forms.DockStyle.Fill;
            this.fpSpread.Location = new System.Drawing.Point(0, 0);
            this.fpSpread.Name = "fpSpread";
            this.fpSpread.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
            this.fpSpread_Sheet1});
            this.fpSpread.Size = new System.Drawing.Size(477, 487);
            this.fpSpread.TabIndex = 0;
            // 
            // fpSpread_Sheet1
            // 
            this.fpSpread_Sheet1.Reset();
            this.fpSpread_Sheet1.SheetName = "Sheet1";
            // Formulas and custom names must be loaded with R1C1 reference style
            this.fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this.fpSpread_Sheet1.ColumnFooter.DefaultStyle.BackColor = System.Drawing.Color.Empty;
            this.fpSpread_Sheet1.ColumnFooter.DefaultStyle.ForeColor = System.Drawing.Color.Empty;
            this.fpSpread_Sheet1.ColumnFooterSheetCornerStyle.BackColor = System.Drawing.Color.Empty;
            this.fpSpread_Sheet1.ColumnFooterSheetCornerStyle.ForeColor = System.Drawing.Color.Empty;
            this.fpSpread_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.Empty;
            this.fpSpread_Sheet1.ColumnHeader.DefaultStyle.ForeColor = System.Drawing.Color.Empty;
            this.fpSpread_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.Empty;
            this.fpSpread_Sheet1.RowHeader.DefaultStyle.ForeColor = System.Drawing.Color.Empty;
            this.fpSpread_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.Empty;
            this.fpSpread_Sheet1.SheetCornerStyle.ForeColor = System.Drawing.Color.Empty;
            this.fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // FinancialKPIControl
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.Name = "FinancialKPIControl";
            this.pnlMain.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread_Sheet1)).EndInit();
            this.ResumeLayout(false);

        }

        #endregion

        private FarPoint.Win.Spread.FpSpread fpSpread;
        private FarPoint.Win.Spread.SheetView fpSpread_Sheet1;
    }
}
